FO_State

This table requires a single record for each state. Its purpose is to match a state full name to its accepted abbreviation.

 

Field Type Notes

State_ID

int

ID field, a counter. Unique

StateCode

varchar(50)

Standard two character state postal abbreviation.

StateName

varchar(80)

Full state name.